<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_userclass`;");
CreateTable("CREATE TABLE `phpyun_userclass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `variable` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=228 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_userclass` values('2','0','婚姻状况','user_marriage','0');");
ExcuteSQL("insert into `phpyun_userclass` values('3','0','教育程度','user_edu','0');");
ExcuteSQL("insert into `phpyun_userclass` values('4','0','工作经验','user_word','0');");
ExcuteSQL("insert into `phpyun_userclass` values('164','160','网络达人','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('163','160','销售精英','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('8','2','已婚','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('9','3','高中以下','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('25','0','技能','user_skill','0');");
ExcuteSQL("insert into `phpyun_userclass` values('11','2','未婚','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('12','3','高中','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('13','3','中专','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('14','3','大专','','4');");
ExcuteSQL("insert into `phpyun_userclass` values('15','3','本科','','5');");
ExcuteSQL("insert into `phpyun_userclass` values('16','3','硕士','','6');");
ExcuteSQL("insert into `phpyun_userclass` values('17','3','博士','','7');");
ExcuteSQL("insert into `phpyun_userclass` values('18','4','应届毕业生','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('19','4','1年以上','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('20','4','2年以上','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('21','4','3年以上','','4');");
ExcuteSQL("insert into `phpyun_userclass` values('22','4','5年以上','','6');");
ExcuteSQL("insert into `phpyun_userclass` values('23','4','8年以上','','8');");
ExcuteSQL("insert into `phpyun_userclass` values('24','4','10年以上','','9');");
ExcuteSQL("insert into `phpyun_userclass` values('26','25','外语','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('27','25','计算机','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('28','25','其他','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('29','0','期待薪资','user_salary','0');");
ExcuteSQL("insert into `phpyun_userclass` values('30','29','面议','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('31','29','1000以下','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('32','29','1000 - 1999','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('33','29','2000 - 2999','','4');");
ExcuteSQL("insert into `phpyun_userclass` values('34','29','3000 - 4499','','5');");
ExcuteSQL("insert into `phpyun_userclass` values('35','29','4500 - 5999','','6');");
ExcuteSQL("insert into `phpyun_userclass` values('36','29','6000 - 7999','','7');");
ExcuteSQL("insert into `phpyun_userclass` values('37','29','8000 - 9999','','8');");
ExcuteSQL("insert into `phpyun_userclass` values('38','29','10000及以上','','9');");
ExcuteSQL("insert into `phpyun_userclass` values('39','0','技能程度','user_ing','0');");
ExcuteSQL("insert into `phpyun_userclass` values('40','39','一般','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('41','39','良好','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('42','39','熟练','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('43','39','精通','','4');");
ExcuteSQL("insert into `phpyun_userclass` values('44','0','到岗时间','user_report','0');");
ExcuteSQL("insert into `phpyun_userclass` values('45','44','随时到岗','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('46','44','1周以内','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('47','44','3周以内','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('48','44','1个月之内','','4');");
ExcuteSQL("insert into `phpyun_userclass` values('50','44','3个月之内','','5');");
ExcuteSQL("insert into `phpyun_userclass` values('51','44','不确定','','6');");
ExcuteSQL("insert into `phpyun_userclass` values('52','0','个人反馈类型','user_message','0');");
ExcuteSQL("insert into `phpyun_userclass` values('53','52','咨询','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('54','52','建议','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('55','52','意见','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('56','0','工作性质','user_type','0');");
ExcuteSQL("insert into `phpyun_userclass` values('57','56','不限','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('58','56','全职','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('59','56','兼职','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('100','4','4年以上','','5');");
ExcuteSQL("insert into `phpyun_userclass` values('101','4','6年以上','','7');");
ExcuteSQL("insert into `phpyun_userclass` values('113','0','求职状态','user_jobstatus','0');");
ExcuteSQL("insert into `phpyun_userclass` values('114','113','已离职，寻求新工作','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('115','113','在职，考虑更好职位','','2');");
ExcuteSQL("insert into `phpyun_userclass` values('116','113','其他','','3');");
ExcuteSQL("insert into `phpyun_userclass` values('118','0','体验周期','user_ecperience','0');");
ExcuteSQL("insert into `phpyun_userclass` values('119','118','1-2天','','1');");
ExcuteSQL("insert into `phpyun_userclass` values('165','160','高级管理','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('162','160','经验足','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('161','160','技术好','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('160','0','个人标签','user_tag','0');");
ExcuteSQL("insert into `phpyun_userclass` values('201','160','海归','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('202','160','世界500强高管','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('203','160','高级工程师','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('219','0','分类标签','user_label','0');");
ExcuteSQL("insert into `phpyun_userclass` values('220','219','已找到工作','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('221','219','正在找工作','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('222','219','兼职工作','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('223','219','寒暑假工','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('224','219','号码为空','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('225','219','信息不符','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('226','219','电话停机','','0');");
ExcuteSQL("insert into `phpyun_userclass` values('227','219','电话无人接听','','0');");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>